Result: MySQL 5.7

Search by: MySQL 5.7 (4)

The length of the word in a FULLTEXT search. The size of the ft_min_word_len key.

The number of characters in a word when searching for a FULLTEXT key. The ft_min_word_len parameter.

06 April 2020 1518 0

MySql 5.7 first setup, change root password and password length

Consider setting up MySql 5.7 access on Ubuntu 18.04. Let's define the mysql root user on the local machine, set the root password for him, consider changing the password length and restrictions on it.

30 March 2019 4234 0

Long-term storage of the basket in the online store

Consider options for popular options for storing goods in a shopping cart in an online store. Let's outline the pros and cons of such storage. Consider options for long-term storage of the basket.

26 January 2019 2688 0

Disabling sql_mode=only_full_group_by in mysql 5.7 ubuntu 18.04

What to do if the error SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db.books' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

20 December 2018 4459 0

Result: MySQL 5.7

The length of the word in a FULLTEXT search. The size of the ft_min_word_len key.

MySql 5.7 first setup, change root password and password length

Long-term storage of the basket in the online store

Disabling sql_mode=only_full_group_by in mysql 5.7 ubuntu 18.04

Tags